BEGIN TRANSACTION

BEGIN TRY 
		DECLARE @B3_Sys INT
		DECLARE @B5_Sys INT
		DECLARE @B9_Sys INT
		DECLARE @FMS_Sys INT
		
		DECLARE @BodyCfeeB3 INT
		DECLARE @BodyCfeeB5 INT
		DECLARE	@BodyCfeeB9 INT
		DECLARE	@BodyFms INT
		
		DECLARE @USER1 INT
		DECLARE @USER2 INT
		DECLARE	@USER3 INT
		DECLARE	@USER4 INT

		DECLARE @TEAM INT
				
		INSERT INTO NOTIFICATION.CCRS_SYSTEM  VALUES('CFEE-B3', NULL)
		SET @B3_Sys  = (SELECT SCOPE_IDENTITY())
		INSERT INTO NOTIFICATION.CCRS_SYSTEM  VALUES('CFEE-B5', NULL)
		SET @B5_Sys  = (SELECT SCOPE_IDENTITY())
		INSERT INTO NOTIFICATION.CCRS_SYSTEM  VALUES('CFEE-B9', NULL)
		SET @B9_Sys  = (SELECT SCOPE_IDENTITY())
		INSERT INTO NOTIFICATION.CCRS_SYSTEM  VALUES('FMS-Outbound', NULL)
		SET @FMS_Sys  = (SELECT SCOPE_IDENTITY())

		INSERT INTO NOTIFICATION.EMAIL_TEMPLATE VALUES('CFEE-B3', 'CFEE Statistical Report', 'Hello,  No statistical report is generated for B3 OutPatient,   Thanks, CCRS Team.', 1, @B3_Sys)
		SET @BodyCfeeB3  = (SELECT SCOPE_IDENTITY())
		INSERT INTO NOTIFICATION.EMAIL_TEMPLATE VALUES('CFEE-B5', 'CFEE Statistical Report', 'Hello,  No statistical report is generated for B5 Pharmacy,   Thanks, CCRS Team.', 1, @B5_Sys)
		SET @BodyCfeeB5  = (SELECT SCOPE_IDENTITY())
		INSERT INTO NOTIFICATION.EMAIL_TEMPLATE VALUES('CFEE-B9', 'CFEE Statistical Report', 'Hello,  No statistical report is generated for B9 InPatient,   Thanks, CCRS Team.', 1, @B9_Sys)
		SET @BodyCfeeB9  = (SELECT SCOPE_IDENTITY())
		INSERT INTO NOTIFICATION.EMAIL_TEMPLATE VALUES('FMS-Outbound', 'FMS Files Upload Status', 'Hello, FMS SFTP has been updated.  Thanks, CCRS Team.', 1, @FMS_Sys)
		SET @BodyFms  = (SELECT SCOPE_IDENTITY())

		INSERT INTO notification.EMAIL_USER values('WLemma@ftc-llc.com', 'Wessen L')
		SET @USER1  = (SELECT SCOPE_IDENTITY())
		INSERT INTO notification.EMAIL_USER values('CSingh@ftc-llc.com', 'Charan S')
		SET @USER2  = (SELECT SCOPE_IDENTITY())
		INSERT INTO notification.EMAIL_USER values('AMalaidakh@ftc-llc.com', 'Andrii M')
		SET @USER3  = (SELECT SCOPE_IDENTITY())
		INSERT INTO notification.EMAIL_USER values('CPineda@ftc-llc.com', 'Cristhian P')
		SET @USER4  = (SELECT SCOPE_IDENTITY())

		INSERT INTO notification.EMAIL_DISTRO values('Team 7 FTC')
		SET @TEAM  = (SELECT SCOPE_IDENTITY())

		INSERT INTO notification.EMAIL_DISTRO_USER values(@TEAM, @USER1)
		INSERT INTO notification.EMAIL_DISTRO_USER values(@TEAM, @USER2)
		INSERT INTO notification.EMAIL_DISTRO_USER values(@TEAM, @USER3)
		INSERT INTO notification.EMAIL_DISTRO_USER values(@TEAM, @USER4)
		INSERT INTO NOTIFICATION.EMAIL_DISTRO_TEMPLATE VALUES(@TEAM, @BodyCfeeB3, 'TO')
		INSERT INTO NOTIFICATION.EMAIL_DISTRO_TEMPLATE VALUES(@TEAM, @BodyCfeeB5, 'TO')
		INSERT INTO NOTIFICATION.EMAIL_DISTRO_TEMPLATE VALUES(@TEAM, @BodyCfeeB9, 'TO')
		INSERT INTO NOTIFICATION.EMAIL_DISTRO_TEMPLATE VALUES(@TEAM, @BodyFms, 'TO')
	
		COMMIT TRANSACTION 
END TRY 

BEGIN CATCH 

     ROLLBACK TRANSACTION

END CATCH   